﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ZhangWuCX.aspx.cs" Inherits="Web.Pages.YongShui._12.ChaXunGL.ZhangWuCX" Theme="Default" %>

<%@ Register Assembly="DevExpress.Web.v15.2, Version=15.2.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>
<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title></title>
    <script src="../../../JS/jquery.js" type="text/javascript"></script>
    <script src="../../../JS/AddEditCancel.js" type="text/javascript"></script>
    <link href="../../../css/inputBgColor.css" rel="stylesheet" />
  
    <script type="text/javascript">
        function SetRowGuanHaoX(values) {
            //根据选中行显示详细信息
            GUAHAO_YHH.SetText(values[0]);
            GUAHAO_YHM.SetText(values[1]);
            GUAHAO_LXR.SetText(values[2]);

            GUAHAO_LXDH.SetText(values[3]);
            GUAHAO_LXBM.SetText(values[4]);


            GUAHAO_YWY.SetText(values[5]);
            GUAHAO_SFFS.SetText(values[6]);
            GUAHAO_YB.SetText(values[7]);

            GUAHAO_CWYB.SetText(values[8]);
            GUAHAO_DZ.SetText(values[9]);
            GUAHAO_CWDZ.SetText(values[10]);

            GUAHAO_YHZH.SetText(values[11]);
            GUAHAO_KHHM.SetText(values[12]);
            GUAHAO_KHYH.SetText(values[13]);
        }
        function CallBack(rs) {
            var list = rs.split('|');
            var type = list[1];
            var msg = list[2];
            var parms = list[0];
            if (parms == "GuaHaoTH") {
                if (type > 0) {

                    alert("退回完成");
                    BtnTuiHui.onClick();
                    LoadPanel.Show();
                    btnChaXun.onClick();
                }
                else {
                    alert("请选择需退回的记录");
                }
            }
            if (parms == "YongHuXX") {

                SetRowGuanHaoX(rs.split('|')[2].split('，'));
                //alert(rs);
            }
            if (parms == "ToGWZ") {

                if (type > 0) {
                    alert(msg);
                } else {
                    btnChaXun.onClick();
                }
            }
        }
        function gvtab7SelectChange() {
            if (gvtab7.GetFocusedRowIndex() > -1) {
                HiddenListValue.Set("NowIndex", gvtab7.GetFocusedRowIndex());
                ASPxCallbackControl.PerformCallback("YongHuXX");
            }
        }
        // 多收转过往帐+
        function gvDuoShoutab6ToGWZ(userid, ym, zwym) {
            HiddenListValue.Set("userid", userid);
            HiddenListValue.Set("slym", ym);
            HiddenListValue.Set("zwym", zwym);
            ASPxCallbackControl.PerformCallback("ToGWZ");
        }
        function GuaHaoTuiHui() {

            ASPxCallbackControl.PerformCallback("GuaHaoTH");
        }
        //多收
        function duoshouRowChange() {
            var valus = gvtab6.GetRowKey(gvtab6.GetFocusedRowIndex());
            gvtab6_2.PerformCallback(valus);
        }

        ///挂号信导入
        function Uploader_OnFileUploadComplete(args) {
            //if (args.isValid) {
            alert(args.callbackData);
            //}
        }

        //tab页签改变
        function TabChange(obj) {
            var index = obj.GetActiveTabIndex();
            if (index == 1 || index == 2 || index == 3) {
                cmbZhangWuY2.SetEnabled(true);
                cmbZhangWuM2.SetEnabled(true);
            }
            else {
                //cmbZhangWuY2.SetText('');
                //cmbZhangWuM2.SetText('');
                cmbZhangWuY2.SetEnabled(false);
                cmbZhangWuM2.SetEnabled(false);
            }
        }

        function textchange1(obj) {
            cmbZhangWuY2.SetText(cmbZhangWuY.GetText());
        }

        function textchange2(obj) {
            cmbZhangWuM2.SetText(cmbZhangWuM.GetText());
        }


        function LoseFocus1() {
            rbnShuiLiangYM.SetChecked("false");
            rbnYongHuH.SetChecked("false");
            rbnYongHuM.SetChecked("false");
        }

        //当用户号或者用户名处于选中状态时
        function LoseFocus_hm() {
            rbnJinECXtab1.SetChecked("false");
            rbnDaoZhangFLtab2.SetChecked("false");
            rbnShouFeiFStab2.SetChecked("false");
            rbnShouFeiJEtab2.SetChecked("false");
            rbnTuiPiaoJEtab3.SetChecked("false");
            rbnTuiPiaoJEtab4.SetChecked("false");
            rbnTuiKuanLEtab4.SetChecked("false");
            rbnLaiHanBHtab4.SetChecked("false");
            rbnHeXiaoJEtab5.SetChecked("false");
            rbnLaiHanBHtab5.SetChecked("false");
            rbnJiaoFeiJEtab8.SetChecked("false");
            rbnJiaoFeiRQtab8.SetChecked("false");
            rbnJiaoFeiLXtab8.SetChecked("false");
            rbnShouFeiRQtab8.SetChecked("false");

        }

    </script>
    <style type="text/css">
        body, html {
            padding: 0;
            margin: 0;
        }
        .FloatLeft { float: left; }
        .FloatRight { float: right; }
        .HideWork { display: none; }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <div class="tabletitle1" align="center">
            账务查询
        </div>
        <dx:ASPxHiddenField ID="HiddenListValue" ClientInstanceName="HiddenListValue" runat="server"></dx:ASPxHiddenField>
        <dx:ASPxCallback ID="ASPxCallbackControl" ClientInstanceName="ASPxCallbackControl" ClientSideEvents-CallbackComplete="function(s,e){CallBack(e.result);}" OnCallback="ASPxCallbackControl_Callback" runat="server"></dx:ASPxCallback>
        <asp:UpdatePanel ID="updatePanel1" runat="server">
            <ContentTemplate>
                <div style="border: 1px solid #d0e4fe; text-align: right;">
                    <table>
                        <tr>
                            <td style="width: 8%;"><span style="font-size: 12px;">账务年月：</span></td>
                            <td style="width: 7%;">
                                <asp:Panel runat="server" ID="Panel1">
                                    <dx:ASPxComboBox runat="server" ID="cmbZhangWuY" Width="100%" ClientInstanceName="cmbZhangWuY">
                                        <Items>
                                            <dx:ListEditItem Text="全部" Value="0" />
                                        </Items>
                                        <ClientSideEvents  TextChanged="function(s,e){textchange1(s);}"/>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td style="width: 6%;">
                                <asp:Panel runat="server" ID="Panel2">
                                    <dx:ASPxComboBox runat="server" ID="cmbZhangWuM" Width="90%" ClientInstanceName="cmbZhangWuM">
                                        <Items>
                                            <dx:ListEditItem Text="全部" Value="0" />
                                        </Items>
                                        <ClientSideEvents  TextChanged="function(s,e){textchange2(s);}"/>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                             <td style="width: 2%;"><span style="font-size: 12px;">&nbsp;</span></td>
                            <td style="width: 7%;">
                                <asp:Panel runat="server" ID="Panel111">
                                    <dx:ASPxComboBox runat="server" ID="cmbZhangWuY2" Width="100%" ClientEnabled="false" ClientInstanceName="cmbZhangWuY2">
                                         <Items>
                                            <dx:ListEditItem Text="全部" Value="0" />
                                        </Items>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td style="width: 6%;">
                                <asp:Panel runat="server" ID="Panel22">
                                    <dx:ASPxComboBox runat="server" ID="cmbZhangWuM2" Width="90%" ClientEnabled="false" ClientInstanceName="cmbZhangWuM2">
                                         <Items>
                                            <dx:ListEditItem Text="全部" Value="0" />
                                        </Items>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td> 
                            <td style="width: 6%;"><span style="font-size: 12px;">站点：</span></td>
                            <td style="width: 8%;">
                                <asp:Panel runat="server" ID="Panel26">
                                    <dx:ASPxComboBox runat="server" ID="cmbGuanLiBM" Width="90%" AutoPostBack="true" OnSelectedIndexChanged="cmbGuanLiBM_SelectedIndexChanged">
                                        <Items>
                                            <dx:ListEditItem Text="全部" Value="" Selected="true" />
                                        </Items>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td style="width: 6%;"><span style="font-size: 12px;">管理块：</span></td>
                            <td style="width: 8%;">
                                <asp:Panel runat="server" ID="Panel27">
                                    <dx:ASPxComboBox runat="server" ID="cmbGuanLiK" Width="90%">
                                        <Items>
                                            <dx:ListEditItem Text="全部" Value="" Selected="true" />
                                        </Items>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td style="width: 6%;"><span style="font-size: 12px;">业务员：</span></td>
                            <td style="width: 8%;">
                                <asp:Panel runat="server" ID="Panel28">
                                    <dx:ASPxComboBox runat="server" ID="cmbYeWuY" Width="90%">
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td>&nbsp;
                                 <dx:ASPxLoadingPanel runat="server" ID="LoadPanel" ClientInstanceName="LoadPanel" Text="正在查询"></dx:ASPxLoadingPanel>
                                <dx:ASPxButton runat="server" ID="btnChaXun" Text="查询" OnClick="btnChaXun_Click" ClientInstanceName="btnChaXun">
                                    <ClientSideEvents Click="function(s,e){LoadPanel.Show();}" />
                                </dx:ASPxButton>
                                <dx:ASPxButton runat="server" ID="btnExportExcel" Text="导出Excel">
                                    <ClientSideEvents  Click="function(s,e){btnExport.OnClick();}"/>
                                </dx:ASPxButton>
                            </td>
                            <td>
                                <dx:ASPxButton runat="server" ID="btnDaYin" Text="打印" Visible="false"></dx:ASPxButton>
                            </td>
                        </tr>
                    </table>
                    <table style="text-align: right; width: 80%;">
                        <tr>
                            <td style="width: 4%;">
                                <dx:ASPxRadioButton runat="server" ID="rbnAll" Text="全部" GroupName="1" ClientInstanceName="rbnAll" Checked="True"></dx:ASPxRadioButton>
                            </td>
                            <td style="width: 4%;">
                                <dx:ASPxRadioButton runat="server" ID="rbnShuiLiangYM" Text="水量年月" GroupName="1" ClientInstanceName="rbnShuiLiangYM"></dx:ASPxRadioButton>
                            </td>
                            <td style="width: 4%;">
                                <asp:Panel runat="server" ID="Panel7">
                                    <dx:ASPxComboBox runat="server" ID="cmbShuiLiangYM1" Width="80%">
                                        <Items>
                                            <dx:ListEditItem Text="" Value="6" />
                                            <dx:ListEditItem Text="=" Value="0" />
                                            <dx:ListEditItem Text=">" Value="1" />
                                            <dx:ListEditItem Text=">=" Value="2" />
                                            <dx:ListEditItem Text="<" Value="3" />
                                            <dx:ListEditItem Text="<=" Value="4" />
                                            <dx:ListEditItem Text="<>" Value="5" />
                                        </Items>
                                        <ClientSideEvents GotFocus="function(s,e){rbnShuiLiangYM.SetChecked(true);LoseFocus_hm();}" />
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td style="width: 6%;">
                                <asp:Panel runat="server" ID="Panel8">
                                    <dx:ASPxTextBox runat="server" ID="txtShuiLiangYM2" Width="80%" MaxLength="6">
                                        <ClientSideEvents KeyUp="function(s,e){inputNum(s);}" GotFocus="function(s,e){rbnShuiLiangYM.SetChecked(true);LoseFocus_hm();}" />
                                    </dx:ASPxTextBox>
                                </asp:Panel>
                            </td>
                            <td style="width: 4%;">
                                <dx:ASPxRadioButton runat="server" ID="rbnYongHuH" Text="用户号"   GroupName="1" ClientInstanceName="rbnYongHuH"></dx:ASPxRadioButton>
                            </td>
                            <td style="width: 6%;">
                                <dx:ASPxTextBox runat="server" ID="txtYongHuH" Width="80%">
                                    <ClientSideEvents GotFocus="function(s,e){rbnYongHuH.SetChecked(true);LoseFocus_hm();}" />
                                </dx:ASPxTextBox>
                            </td>
                            <td style="width: 4%;">
                                <dx:ASPxRadioButton runat="server" ID="rbnYongHuM" Text="用户名" GroupName="1" ClientInstanceName="rbnYongHuM"></dx:ASPxRadioButton>
                            </td>
                            <td style="width: 10%;">
                                <dx:ASPxTextBox runat="server" ID="txtYongHuM" Width="80%">
                                    <ClientSideEvents GotFocus="function(s,e){rbnYongHuM.SetChecked(true);LoseFocus_hm();}" />
                                </dx:ASPxTextBox>
                            </td>
                        </tr>
                    </table>
                </div>
                <div>
                    <dx:ASPxPageControl ID="ASPxPageControl1" ClientInstanceName="ASPxPageControl1" runat="server" ActiveTabIndex="6" Width="98%" AutoPostBack="false">
                        <ClientSideEvents  ActiveTabChanged="function(s,e){TabChange(s);}"/>
                        <TabPages>
                            <dx:TabPage Text="本期信息">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div style="border: 1px solid #d0e4fe; width: 100%; height: 30px;">
                                            <table>
                                                <tr>
                                                    <td style="width: 10%;">
                                                        <dx:ASPxRadioButton runat="server" ID="rbnJinECXtab1" Text="金额查询" GroupName="1" ClientInstanceName="rbnJinECXtab1">
                                                            <ClientSideEvents GotFocus="function(s,e){LoseFocus();}" />
                                                        </dx:ASPxRadioButton>
                                                    </td>
                                                    <td style="width: 7%;">
                                                        <asp:Panel runat="server" ID="Panel10">
                                                            <dx:ASPxComboBox runat="server" ID="cmbJinECXtab1" Width="100%">
                                                                <Items>
                                                                    <dx:ListEditItem Text="初开" Value="N_CHUKAIJE"  />
                                                                    <dx:ListEditItem Text="实收" Value="N_SHISHOUJE" />
                                                                    <dx:ListEditItem Text="核销金额" Value="N_QIANFEITZ" />
                                                                    <dx:ListEditItem Text="欠费" Value="N_QIANFEI" />
                                                                </Items>
                                                                <ClientSideEvents GotFocus="function(s,e){rbnJinECXtab1.SetChecked(true);LoseFocus1();}" />
                                                            </dx:ASPxComboBox>
                                                        </asp:Panel>
                                                    </td>
                                                    <td style="width: 7%;">
                                                        <asp:Panel runat="server" ID="Panel9">
                                                            <dx:ASPxComboBox runat="server" ID="cmbJinECX2tab1" Width="100%">
                                                                <Items>
                                                                    <dx:ListEditItem Text="" Value="6" />
                                                                    <dx:ListEditItem Text="=" Value="0" />
                                                                    <dx:ListEditItem Text=">" Value="1" />
                                                                    <dx:ListEditItem Text=">=" Value="2" />
                                                                    <dx:ListEditItem Text="<" Value="3" />
                                                                    <dx:ListEditItem Text="<=" Value="4" />
                                                                    <dx:ListEditItem Text="<>" Value="5" />
                                                                </Items>
                                                                <ClientSideEvents GotFocus="function(s,e){rbnJinECXtab1.SetChecked(true);LoseFocus1();}" />
                                                            </dx:ASPxComboBox>
                                                        </asp:Panel>
                                                    </td>
                                                    <td style="width: 7%;">
                                                        <dx:ASPxTextBox runat="server" ID="txtJinECXtab1" Width="100%">
                                                            <ClientSideEvents GotFocus="function(s,e){rbnJinECXtab1.SetChecked(true);LoseFocus1();}" />
                                                        </dx:ASPxTextBox>
                                                    </td>
                                                    <td style="width: 7%;">
                                                        <dx:ASPxCheckBox runat="server" Text="欠费" ID="chkQianFeitab1"></dx:ASPxCheckBox>
                                                    </td>
                                                   <%-- <td>
                                                        <dx:ASPxButton runat="server" ID="btnExportDBF" Text="导出DBF"></dx:ASPxButton>
                                                    </td>--%>
                                                    <td style="width: 30%;">&nbsp;</td>
                                                   <%-- <td style="width: 5%">
                                                        <img src="../../../Images/first.jpg" />
                                                    </td>
                                                    <td style="width: 5%">
                                                        <img src="../../../Images/last.jpg" />
                                                    </td>
                                                    <td style="width: 5%">
                                                        <img src="../../../Images/next.jpg" />
                                                    </td>
                                                    <td style="width: 5%">
                                                        <img src="../../../Images/final.jpg" />
                                                    </td>--%>
                                                </tr>
                                            </table>
                                        </div>
                                        <div style="border: 1px solid #d0e4fe; width: 100%;">

                                            <div>
                                                <dx:ASPxGridView ID="gvBenQiXXTab1" ClientInstanceName="gvtab1" runat="server" AutoGenerateColumns="False"
                                                    KeyFieldName="S_YONGHUH" EnableCallBacks="true" ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%">
                                                    <%-- <ClientSideEvents FocusedRowChanged="function(s,e){rowClick();}" />--%>

                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvtab1);}" />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="100" FirstPageButton-Visible="true" >
                                                        <FirstPageButton Visible="True">
                                                        </FirstPageButton>
                                                        <LastPageButton Visible="True">
                                                        </LastPageButton>
                                                    </SettingsPager>

                                                    <Settings VerticalScrollBarMode="Visible" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="300">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_SLYM" Caption="水量年月" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_KZYM" Caption="开帐年月" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_CHUKAIJE" Caption="初开金额" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_SHISHOUJE" Caption="实收金额" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_QIANFEITZ" Caption="核销金额" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_QIANFEI" Caption="欠费" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YEWUYM" Caption="业务员" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_HUISHOUL" Caption="回收率(%)" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_SHISHOUYK" Caption="实收/应收" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_DUOSHOU" Caption="多收" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_SHIYONGSL" Caption="实用水量" Width="70" >
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_JIAJIAYSL" Caption="加价水量" Width="70" >
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_KAIZHANGRQ" Caption="开帐日期" Width="80" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                                                            <PropertiesTextEdit DisplayFormatString="yyyy-MM-dd">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>

                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 8%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab1" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">开帐金额：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtKaiZhangJEtab1" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">实收金额：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtShiShouJEtab1" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">核销金额：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtHeXiaoJEtab1" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">欠费：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtQianFeitab1" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">多收：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtDuoShoutab1" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </fieldset>

                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="本月到账">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <div style="border: 1px solid #d0e4fe;">
                                                <table>
                                                    <tr>
                                                        <td style="width: 7%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnDaoZhangFLtab2" Text="到账分类" GroupName="1" ClientInstanceName="rbnDaoZhangFLtab2"></dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <asp:Panel runat="server" ID="Panel4">
                                                                <dx:ASPxComboBox runat="server" ID="cmbChaoBiaoBMtab2" Width="90%" AutoPostBack="true">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="0" />
                                                                        <dx:ListEditItem Text="本月到帐" Value="1" />
                                                                        <dx:ListEditItem Text="旧欠到帐" Value="2" />
                                                                        <dx:ListEditItem Text="本月托收到帐" Value="3" />
                                                                        <dx:ListEditItem Text="本月非托收到帐" Value="4" />
                                                                        <dx:ListEditItem Text="旧欠托收" Value="5" />
                                                                        <dx:ListEditItem Text="旧欠初托收" Value="6" />
                                                                        <dx:ListEditItem Text="旧欠重托收" Value="7" />
                                                                        <dx:ListEditItem Text="旧欠非托收到账" Value="8" />
                                                                        <dx:ListEditItem Text="托收到帐（全部）" Value="9" />
                                                                        <dx:ListEditItem Text="非托收到帐（全部）" Value="10" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnDaoZhangFLtab2.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 6%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnShouFeiFStab2" Text="收费方式" GroupName="1" ClientInstanceName="rbnShouFeiFStab2"></dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <asp:Panel runat="server" ID="Panel11">
                                                                <dx:ASPxComboBox runat="server" ID="cmbShuiLiangYtab2" Width="90%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="0" />
                                                                        <dx:ListEditItem Text="304_本月托收" Value="304"  />
                                                                        <dx:ListEditItem Text="305_旧欠托收" Value="305" />
                                                                        <dx:ListEditItem Text="999_现金支票付委" Value="999" />
                                                                        <dx:ListEditItem Text="301_现金" Value="301" />
                                                                        <dx:ListEditItem Text="302_支票" Value="302" />
                                                                        <dx:ListEditItem Text="303_付委" Value="303" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnShouFeiFStab2.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxCheckBox runat="server" ID="chkPaiChuSYYStab2" Text="排除上月预收"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxCheckBox runat="server" ID="chkBaoHanSYYStab2" Text="包含上月预收"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 6%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnShouFeiJEtab2" Text="收费金额" GroupName="1" ClientInstanceName="rbnShouFeiJEtab2"></dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 4%;">
                                                            <asp:Panel runat="server" ID="Panel3">
                                                                <dx:ASPxComboBox runat="server" ID="cmbShouFeiFStab2" Width="80%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="0"  />
                                                                        <dx:ListEditItem Text="=" Value="1"  />
                                                                        <dx:ListEditItem Text=">" Value="2" />
                                                                        <dx:ListEditItem Text=">=" Value="3" />
                                                                        <dx:ListEditItem Text="<" Value="4" />
                                                                        <dx:ListEditItem Text="<=" Value="5" />
                                                                        <dx:ListEditItem Text="<>" Value="6" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnShouFeiJEtab2.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <asp:Panel runat="server" ID="Panel13">
                                                                <dx:ASPxTextBox runat="server" ID="txtShouFeiFStab2" Width="80%">
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnShouFeiJEtab2.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxTextBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <%--<td style="width: 5%">
                                                            <img src="../../../Images/first.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/last.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/next.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/final.jpg" />
                                                        </td>--%>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div>
                                                <dx:ASPxGridView ID="gvBenYueDZtab2" ClientInstanceName="gvtab2" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YHH"
                                                    EnableCallBacks="true" ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%">
                                                    <%--<Settings  VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />--%>
                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvtab2);}" />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="100" AlwaysShowPager="true" FirstPageButton-Visible="true" >
                                                        <FirstPageButton Visible="True">
                                                        </FirstPageButton>
                                                        <LastPageButton Visible="True">
                                                        </LastPageButton>
                                                    </SettingsPager>
                                                    <Settings VerticalScrollBarMode="Visible" VerticalScrollableHeight="400" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YHH" Caption="用户号" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YHM" Caption="用户名" Width="280">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_SLYM" Caption="水量年月" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_ZWYM" Caption="收费日期" Width="80" >
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_SFJE" Caption="收费金额" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_SFFS" Caption="收费方式" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YWYM" Caption="业务员" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YHZH" Caption="银行帐号" Width="130">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_KHYH" Caption="开户银行" Width="180">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_KHHM" Caption="开户户名" Width="200">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_TSPZ" Caption="托收凭证" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_CZY" Caption="操作员" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_CZRQ" Caption="操作日期" Width="80" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                                                            <PropertiesTextEdit DisplayFormatString="yyyy-MM-dd">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_FPHM" Caption="发票号码" Width="120">
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 7%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab2" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            <td style="width: 50%;">&nbsp;</td>
                                                            <td style="width: 8%;"><span style="font-size: 12px;">收费金额汇总：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtShouFeiJEHZtab2" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="退票">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <div style="border: 1px solid #d0e4fe;">
                                                <table>
                                                    <tr>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnTuiPiaoJEtab3" ClientInstanceName="rbnTuiPiaoJEtab3" Text="退票金额">
                                                               
                                                            </dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 5%;">
                                                            <asp:Panel runat="server" ID="Panel12">
                                                                <dx:ASPxComboBox runat="server" ID="cmbTuiPiaoJEtab3" Width="80%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="0" />
                                                                        <dx:ListEditItem Text="=" Value="1" />
                                                                        <dx:ListEditItem Text=">" Value="2" />
                                                                        <dx:ListEditItem Text=">=" Value="3" />
                                                                        <dx:ListEditItem Text="<" Value="4" />
                                                                        <dx:ListEditItem Text="<=" Value="5" />
                                                                        <dx:ListEditItem Text="<>" Value="6" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnTuiPiaoJEtab3.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <dx:ASPxTextBox runat="server" ID="txtTuiPiaoJEtab3" Width="80%" ClientInstanceName="txtTuiPiaoJEtab3">
                                                                <ClientSideEvents GotFocus="function(s,e){rbnTuiPiaoJEtab3.SetChecked(true);LoseFocus1();}" />
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxCheckBox runat="server" ID="chkShouGongTPtab3" Text="手工退票"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 35%;">&nbsp;</td>
                                                       <%-- <td style="width: 5%">
                                                            <img src="../../../Images/first.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/last.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/next.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/final.jpg" />
                                                        </td>--%>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div>
                                                <dx:ASPxGridView ID="gvTuiPiaotab3" ClientInstanceName="gvtab3" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YONGHUH"
                                                    EnableCallBacks="true" ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%">
                                                    <%-- <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />--%>
                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvtab3);}" />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="100" AlwaysShowPager="true" FirstPageButton-Visible="true" >
                                                        <FirstPageButton Visible="True">
                                                        </FirstPageButton>
                                                        <LastPageButton Visible="True">
                                                        </LastPageButton>
                                                    </SettingsPager>
                                                    <Settings VerticalScrollBarMode="Visible" VerticalScrollableHeight="400" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="280">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_SLYM" Caption="水量年月" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_TUIPIAORQ" Caption="退票日期" Width="80" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                                                            <PropertiesTextEdit DisplayFormatString="yyyy-MM-dd">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_TUIPIAOJE" Caption="退票金额" Width="65">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_TUIPIAOLY" Caption="退票理由" Width="200">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YWYM" Caption="业务员" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YINHANGZH" Caption="银行账号" Width="120">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_KAIHUYH" Caption="开户银行" Width="180">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_KAIHUYHMC" Caption="开户户名" Width="200">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_TUOSHOUPZH" Caption="托收凭证号" Width="100">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_CAOZUOY" Caption="操作员" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_CAOZUORQ" Caption="操作日期" Width="80" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                                                            <PropertiesTextEdit DisplayFormatString="yyyy-MM-dd">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_CAOZUOSX" Caption="操作顺序号" Width="120">
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 7%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab3" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            <td style="width: 50%;">&nbsp;</td>
                                                            <td style="width: 8%;"><span style="font-size: 12px;">退票金额汇总：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtTuiPiaoJEHZtab3" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="退款">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <div style="border: 1px solid #d0e4fe;">
                                                <table>
                                                    <tr>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnTuiPiaoJEtab4" Text="退票金额" GroupName="tab4" ClientInstanceName="rbnTuiPiaoJEtab4"></dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 6%;">
                                                            <asp:Panel runat="server" ID="Panel5">
                                                                <dx:ASPxComboBox runat="server" ID="cbmTuiPiaoJEtab4" Width="80%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="0" />
                                                                        <dx:ListEditItem Text="=" Value="1" />
                                                                        <dx:ListEditItem Text=">" Value="2" />
                                                                        <dx:ListEditItem Text=">=" Value="3" />
                                                                        <dx:ListEditItem Text="<" Value="4" />
                                                                        <dx:ListEditItem Text="<=" Value="5" />
                                                                        <dx:ListEditItem Text="<>" Value="6" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnTuiPiaoJEtab4.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <asp:Panel runat="server" ID="Panel6">
                                                                <dx:ASPxTextBox runat="server" ID="txtTuiPiaoJE2tab4" Width="90%">
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnTuiPiaoJEtab4.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxTextBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnTuiKuanLEtab4" Text="退款类型" GroupName="tab4" ClientInstanceName="rbnTuiKuanLEtab4"></dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <asp:Panel runat="server" ID="Panel16">
                                                                <dx:ASPxComboBox runat="server" ID="cbmTuiKuanLEtab4" Width="90%">
                                                                     <Items>
                                                                        <dx:ListEditItem Text="321_收错退款" Value="321" />
                                                                        <dx:ListEditItem Text="322_多收退款" Value="322" />
                                                                        <dx:ListEditItem Text="324_调整退款" Value="324" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnTuiKuanLEtab4.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnLaiHanBHtab4" Text="来函编号" GroupName="tab4" ClientInstanceName="rbnLaiHanBHtab4"></dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 9%">
                                                            <dx:ASPxTextBox runat="server" ID="txtLaiHanBHtab4" Width="80%">
                                                                <ClientSideEvents GotFocus="function(s,e){rbnLaiHanBHtab4.SetChecked(true);LoseFocus1();}" />
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 35%;">&nbsp;</td>
                                                        <%--<td style="width: 5%">
                                                            <img src="../../../Images/first.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/last.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/next.jpg" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/final.jpg" />
                                                        </td>--%>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div>
                                                <dx:ASPxGridView ID="gvTuiKuantab4" ClientInstanceName="gvtab4" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YONGHUH"
                                                    EnableCallBacks="true" ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%">
                                                    <%--<Settings  VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />--%>
                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvtab4);}" />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="100" AlwaysShowPager="true" FirstPageButton-Visible="true" >
                                                        <FirstPageButton Visible="True">
                                                        </FirstPageButton>
                                                        <LastPageButton Visible="True">
                                                        </LastPageButton>
                                                    </SettingsPager>
                                                    <Settings VerticalScrollBarMode="Visible" VerticalScrollableHeight="400" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="6%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="20%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_SLYM" Caption="水量年月" Width="7%" CellStyle-HorizontalAlign="Center">
                                                            <CellStyle HorizontalAlign="Center">
                                                            </CellStyle>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_TIAOZHENGRQ" Caption="退款日期" Width="7%" PropertiesTextEdit-DisplayFormatString="yyyyMM" CellStyle-HorizontalAlign="Center">
                                                            <PropertiesTextEdit DisplayFormatString="yyyyMM">
                                                            </PropertiesTextEdit>
                                                            <CellStyle HorizontalAlign="Center">
                                                            </CellStyle>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_TIAOZHENGJE" Caption="退款金额" Width="7%" CellStyle-HorizontalAlign="Right">
                                                            <CellStyle HorizontalAlign="Right">
                                                            </CellStyle>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_TUIKUANLX" Caption="退款类型" Width="7%" CellStyle-HorizontalAlign="Center">
                                                            <CellStyle HorizontalAlign="Center">
                                                            </CellStyle>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YWYM" Caption="业务员" Width="7%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_PIWENH" Caption="来函编号" Width="8%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="" Caption="注销发票号" Width="9%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_CAOZUOY" Caption="操作员" Width="7%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_CAOZUORQ" Caption="操作日期" Width="7%" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd" CellStyle-HorizontalAlign="Center">
                                                            <PropertiesTextEdit DisplayFormatString="yyyy-MM-dd">
                                                            </PropertiesTextEdit>
                                                            <CellStyle HorizontalAlign="Center">
                                                            </CellStyle>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="ID" Caption="操作顺序号" Width="8%">
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 7%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab4" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            <td style="width: 50%;">&nbsp;</td>
                                                            <td style="width: 8%;"><span style="font-size: 12px;">退款合计：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtTuiKuanHJtab4" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="计划变更">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <div style="border: 1px solid #d0e4fe;">
                                                <table>
                                                    <tr>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnHeXiaoJEtab5" Text="核销金额" GroupName="tab5" ClientInstanceName="rbnHeXiaoJEtab5"></dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 6%;">
                                                            <asp:Panel runat="server" ID="Panel17">
                                                                <dx:ASPxComboBox runat="server" ID="cbmHeXiaoJEtab5" Width="80%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="0" />
                                                                        <dx:ListEditItem Text="=" Value="1" />
                                                                        <dx:ListEditItem Text=">" Value="2" />
                                                                        <dx:ListEditItem Text=">=" Value="3" />
                                                                        <dx:ListEditItem Text="<" Value="4" />
                                                                        <dx:ListEditItem Text="<=" Value="5" />
                                                                        <dx:ListEditItem Text="<>" Value="6" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnHeXiaoJEtab5.SetChecked(true);LoseFocus1();}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <dx:ASPxTextBox runat="server" ID="txtHeXiaoJEtab5" Width="80%">
                                                                <ClientSideEvents GotFocus="function(s,e){rbnHeXiaoJEtab5.SetChecked(true);LoseFocus1();}" />
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxRadioButton runat="server" ID="rbnLaiHanBHtab5" Text="来函编号" GroupName="tab5" ClientInstanceName="rbnLaiHanBHtab5"></dx:ASPxRadioButton>
                                                        </td>
                                                        <td style="width: 9%">
                                                            <dx:ASPxTextBox runat="server" ID="txtLaiHanBHtab5" Width="80%">
                                                                <ClientSideEvents GotFocus="function(s,e){rbnLaiHanBHtab5.SetChecked(true);LoseFocus1();}" />
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 35%;">&nbsp;</td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/first.jpg" style="display:none"/>
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/last.jpg" style="display:none" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/next.jpg" style="display:none" />
                                                        </td>
                                                        <td style="width: 5%">
                                                            <img src="../../../Images/final.jpg" style="display:none" />
                                                        </td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div>
                                                <dx:ASPxGridView ID="gvJiHuaBGtab5" ClientInstanceName="gvtab5" runat="server" AutoGenerateColumns="False" KeyFieldName="ID" EnableCallBacks="false" Theme="Aqua1" Width="100%">
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="8%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="27%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_YM" Caption="水量年月" Width="8%" CellStyle-HorizontalAlign="Center">
                                                            <CellStyle HorizontalAlign="Center">
                                                            </CellStyle>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_BIANGENGRQ" Caption="变更日期" Width="8%" CellStyle-HorizontalAlign="Center">
                                                            <CellStyle HorizontalAlign="Center">
                                                            </CellStyle>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_HEXIAOJE" Caption="核销金额" Width="8%" PropertiesTextEdit-DisplayFormatString="0.00">
                                                            <PropertiesTextEdit DisplayFormatString="0.00">
                                                            </PropertiesTextEdit>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_LAIHANBH" Caption="来函编号" Width="9%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YWY" Caption="业务员" Width="8%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_TIAOZHENGY" Caption="操作员" Width="8%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_CAOZUOSJ" Caption="操作日期" Width="8%" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd" CellStyle-HorizontalAlign="Center">
                                                            <PropertiesTextEdit DisplayFormatString="yyyy-MM-dd">
                                                            </PropertiesTextEdit>
                                                            <CellStyle HorizontalAlign="Center">
                                                            </CellStyle>
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="ID" Caption="操作顺序号" Width="8%">
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvtab5);}" />
                                                    <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 7%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab5" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            <td style="width: 50%;">&nbsp;</td>
                                                            <td style="width: 8%;"><span style="font-size: 12px;">核销金额汇总：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtHeXiaoJEHZtab5" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="多收">
                                <ContentCollection>
                                    <dx:ContentControl>

                                        <dx:ASPxGridView ID="gvDuoShoutab6" ClientInstanceName="gvtab6" runat="server" AutoGenerateColumns="False" KeyFieldName="KEYFIELD" Theme="Aqua1" Width="100%">
                                            <Columns>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="10%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="40%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="I_YM" Caption="水量年月" Width="10%" CellStyle-HorizontalAlign="Left">
                                                    <CellStyle HorizontalAlign="Left">
                                                    </CellStyle>
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="D_DUOSHOURQ" Caption="多收日期" Width="10%" CellStyle-HorizontalAlign="Left">
                                                    <CellStyle HorizontalAlign="Left">
                                                    </CellStyle>
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="N_YINGSHOUJE" Caption="应收金额" Width="10%" PropertiesTextEdit-DisplayFormatString="0.00">
                                                    <PropertiesTextEdit DisplayFormatString="0.00">
                                                    </PropertiesTextEdit>
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="N_DUOSHOUJE" Caption="多收金额" Width="10%" PropertiesTextEdit-DisplayFormatString="0.00">
                                                    <PropertiesTextEdit DisplayFormatString="0.00">
                                                    </PropertiesTextEdit>
                                                </dx:GridViewDataTextColumn>
                                                <%-- <dx:GridViewDataTextColumn FieldName="" Caption="未处理金额" Width="10%"></dx:GridViewDataTextColumn>--%>
                                                <dx:GridViewDataTextColumn FieldName="S_YWY" Caption="业务员" Width="10%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_FPHM" Caption="发票号码" Width="10%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn Width="8%">
                                                    <DataItemTemplate>
                                                        <a href="#" onclick='gvDuoShoutab6ToGWZ("<%#Eval("S_YONGHUH")%>", <%#Eval("I_YM")%>, <%#Eval("D_DUOSHOURQ")%>)'
                                                            class='<%#Eval("S_FPHM").ToString().Length == 0 &&  m_CurrentUserID == 99999 ? "" : "HideWork"%>'>转过往帐+</a>
                                                    </DataItemTemplate>
                                                </dx:GridViewDataTextColumn>
                                            </Columns>
                                            <ClientSideEvents Init="function(s,e){AdjustSize(340,gvtab6);}" FocusedRowChanged="function(s,e){duoshouRowChange();}" />
                                            <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                            <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                        </dx:ASPxGridView>

                                        <fieldset style="border: 1px solid #d0e4fe;">
                                            <legend>汇总</legend>
                                            <div style="float: left">
                                                <table style="text-align: right;">
                                                    <tr>
                                                        <td style="width: 100px;"><span style="font-size: 12px;">多收金额汇总：</span></td>
                                                        <td style="width: 120px;">
                                                            <dx:ASPxTextBox runat="server" ID="txtDuoShouJEHZtab6" Enabled="false" HorizontalAlign="Right" Width="80%"></dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 100px;"><span style="font-size: 12px;">未处理金额汇总：</span></td>
                                                        <td style="width: 120px;">
                                                            <dx:ASPxTextBox runat="server" ID="txtWeiChuLJEHZtab6" Enabled="false" HorizontalAlign="Right" Width="80%"></dx:ASPxTextBox>
                                                        </td>
                                                        <td>
                                                             <dx:ASPxLabel runat="server" ID="lbZongBiStab6" Text="共0笔"></dx:ASPxLabel> 
                                                        </td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div style="float: right; text-align: right;">
                                                <dx:ASPxCheckBox ID="CbxNotFP" runat="server" Text="无发票号码"></dx:ASPxCheckBox>
                                            </div>
                                        </fieldset>
                                        <fieldset style="border: 1px solid #d0e4fe;">
                                            <legend>多收处理</legend>
                                            <dx:ASPxGridView ID="gvDuoShou_DuoShouCLtab6" ClientInstanceName="gvtab6_2" runat="server" AutoGenerateColumns="False" KeyFieldName="支出日期" EnableCallBacks="true" Theme="Aqua1" Width="400" OnCustomCallback="gvDuoShou_DuoShouCLtab6_CustomCallback">
                                                <Columns>
                                                    <dx:GridViewDataTextColumn FieldName="支出日期" Caption="支出日期" Width="33%" HeaderStyle-HorizontalAlign="Center">
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="支出方式" Caption="支出方式" Width="33%" HeaderStyle-HorizontalAlign="Center">
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="支出金额" Caption="支出金额" Width="33%" HeaderStyle-HorizontalAlign="Center" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        <PropertiesTextEdit DisplayFormatString="0.00">
                                                        </PropertiesTextEdit>
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                </Columns>
                                                <Settings VerticalScrollableHeight="180" VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />
                                            </dx:ASPxGridView>
                                        </fieldset>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="挂号信">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <table>
                                                <tr>
                                                    <td style="width: 7%;">
                                                        <div style="display: none">
                                                            <dx:ASPxButton runat="server" ID="btnTuiHuitab7" ClientInstanceName="BtnTuiHui" Text="退回" OnClick="btnTuiHuitab7_Click"></dx:ASPxButton>

                                                        </div>
                                                        <dx:ASPxButton runat="server" ID="BtnTuiHui" AutoPostBack="false" Text="退回">
                                                            <ClientSideEvents Click="function(s,e){GuaHaoTuiHui();}" />
                                                        </dx:ASPxButton>

                                                    </td>
                                                  
                                                    <td style="width: 7%;">
                                                        <dx:ASPxLabel runat="server" ID="lbZongBiStab7" Text="共0笔"></dx:ASPxLabel>
                                                    </td>
                                                    <td style="width: 50%;">
                                                        <div>
                                                            <script type="text/javascript">
                                                                function first7(obj, msg, key) {

                                                                    obj.SetFocusedRowIndex(0);
                                                                    gvtab7ScrollToVisibleIndexOnClient(0);
                                                                }

                                                                function last7(obj, msg, key) {
                                                                    var index = obj.GetFocusedRowIndex() - 1;
                                                                    if (obj.GetFocusedRowIndex() == 0) {
                                                                        alert("当前已是第一条");
                                                                    }
                                                                    else {
                                                                        obj.SetFocusedRowIndex(obj.GetFocusedRowIndex() - 1);

                                                                    }
                                                                    gvtab7ScrollToVisibleIndexOnClient(index);
                                                                }

                                                                function next7(obj, msg, key) {
                                                                    var index = obj.GetFocusedRowIndex() + 1;
                                                                    if (obj.GetFocusedRowIndex() == obj.GetVisibleRowsOnPage() - 1) {
                                                                        alert("当前已是最后一条");
                                                                    }
                                                                    else {

                                                                        obj.SetFocusedRowIndex(obj.GetFocusedRowIndex() + 1);

                                                                    }
                                                                    gvtab7ScrollToVisibleIndexOnClient(index);
                                                                }

                                                                function final7(obj, msg, key) {
                                                                    var index = obj.GetVisibleRowsOnPage() - 1;
                                                                    obj.SetFocusedRowIndex(index);
                                                                    gvtab7ScrollToVisibleIndexOnClient(index);
                                                                }
                                                                function gvtab7ScrollToVisibleIndexOnClient(index) {
                                                                    //alert(gvtab7.GetVerticalScrollPosition());
                                                                    //alert(index);
                                                                    gvtab7.SetVerticalScrollPosition(index * 30);
                                                                }
                                                            </script>
                                                            <table>
                                                                <tr>
                                                                    <td style="width: 70px; cursor: pointer">
                                                                        <div onclick="first7(gvtab7,'setinfo','ID');">
                                                                            <img src="../../../Images/first.jpg" />
                                                                        </div>
                                                                    </td>
                                                                    <td style="width: 70px; cursor: pointer">
                                                                        <div onclick="last7(gvtab7,'setinfo','ID');">
                                                                            <img src="../../../Images/last.jpg" />
                                                                        </div>
                                                                    </td>
                                                                    <td style="width: 70px; cursor: pointer">
                                                                        <div onclick="next7(gvtab7,'setinfo','ID');">
                                                                            <img src="../../../Images/next.jpg" />
                                                                        </div>
                                                                    </td>
                                                                    <td style="width: 70px; cursor: pointer">
                                                                        <div onclick="final7(gvtab7,'setinfo','ID');">
                                                                            <img src="../../../Images/final.jpg" />
                                                                        </div>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </div>
                                                    </td>
                                                    <td style="width: 7%;">
                                                        <dx:ASPxButton runat="server" Visible="false" ID="btnImportExceltab7" Text="导入Excel" OnClick="btnImportExceltab7_Click">
                                                        </dx:ASPxButton>
                                                        <dx:ASPxUploadControl ID="UpLoadFile" runat="server" ClientInstanceName="uploader"
                                                            ShowTextBox="false" Theme="Aqua" UploadMode="Standard" ShowClearFileSelectionButton="False"
                                                            ShowProgressPanel="false" NullText="" OnFileUploadComplete="UpLoadFile_FileUploadComplete"
                                                            Width="0px">
                                                            <BrowseButton Text="导入Excel"></BrowseButton>
                                                            <ClientSideEvents FileUploadComplete="function(s, e) { Uploader_OnFileUploadComplete(e); }"
                                                                TextChanged="function(s, e) { uploader.Upload();}"></ClientSideEvents>
                                                            <ValidationSettings MaxFileSize="4194304" AllowedFileExtensions=".xls,.xlsx">
                                                            </ValidationSettings>
                                                        </dx:ASPxUploadControl>
                                                    </td>
                                                </tr>
                                            </table>
                                        </div>
                                        <div>
                                            <dx:ASPxGridView ID="gvGuaHaoXtab7"   ClientInstanceName="gvtab7"   runat="server" AutoGenerateColumns="False" KeyFieldName="I_ID" Theme="Aqua1" Width="100%" OnRowCommand="gvGuaHaoXtab7_RowCommand">
                                                <Columns>
                                                    <dx:GridViewDataTextColumn FieldName="" Caption="" Width="5%" HeaderStyle-HorizontalAlign="Center" VisibleIndex="11">
                                                        <DataItemTemplate>
                                                            <dx:ASPxCheckBox ID="ck" runat="server" ToolTip='<%#Eval("I_ID") %>' Visible='<%#Eval("I_ZHUANGTAI").ToString()!="1" %>'></dx:ASPxCheckBox>
                                                        </DataItemTemplate>
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="10%" HeaderStyle-HorizontalAlign="Center" VisibleIndex="12">
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="25%" VisibleIndex="13"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="YM" Caption="水量年月" Width="10%" HeaderStyle-HorizontalAlign="Center" VisibleIndex="14">
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="N_YINGSHOUJE" Caption="加价金额" Width="10%" HeaderStyle-HorizontalAlign="Center" VisibleIndex="15">
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_HAOMA" Caption="发票编号" Width="15%" HeaderStyle-HorizontalAlign="Center" VisibleIndex="16">
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_GUAHUAOXH" Caption="挂号信编号" Width="15%" HeaderStyle-HorizontalAlign="Center" VisibleIndex="17">
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="D_YOUJIRQ" Caption="邮寄日期" PropertiesTextEdit-DisplayFormatString="{0:yyyy-MM-dd}" Width="15%" HeaderStyle-HorizontalAlign="Center" VisibleIndex="18">
                                                        <PropertiesTextEdit DisplayFormatString="{0:yyyy-MM-dd}">
                                                        </PropertiesTextEdit>
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="ZHUANGTAI" Caption="是否退回" Width="15%" HeaderStyle-HorizontalAlign="Center" VisibleIndex="19">
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>

                                                    
                                                    <dx:GridViewDataTextColumn FieldName="S_LIANXIR" Visible="false"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_LIANXIBM" Visible="false" VisibleIndex="0"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_LIANXIDZ" Visible="false" VisibleIndex="1"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="USERNAME" Visible="false" VisibleIndex="2"></dx:GridViewDataTextColumn>

                                                    <dx:GridViewDataTextColumn FieldName="SFFS" Visible="false" VisibleIndex="3"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_YOUBIAN" Visible="false" VisibleIndex="4"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="CWYB" Visible="false" VisibleIndex="5"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="CWDZ" Visible="false" VisibleIndex="6"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_DIZHI" Visible="false" VisibleIndex="7"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_YINHANGZH" Visible="false" VisibleIndex="8"></dx:GridViewDataTextColumn>

                                                    <dx:GridViewDataTextColumn FieldName="S_KAIHUHM" Visible="false" VisibleIndex="9"></dx:GridViewDataTextColumn>
                                                    <dx:GridViewDataTextColumn FieldName="S_KAIHUYH" Visible="false" VisibleIndex="10"></dx:GridViewDataTextColumn>

                                                    <dx:GridViewDataTextColumn Caption="恢复"  ShowInCustomizationForm="True" VisibleIndex="20"  HeaderStyle-HorizontalAlign="Center">
                                                        <DataItemTemplate>
                                                             &nbsp;  &nbsp; &nbsp;<asp:Button ID="btnRenew" runat="server" BackColor="#3399FF" BorderStyle="None" Font-Names="微软雅黑" Font-Size="12px" ForeColor="White" CommandName="renew" CommandArgument='<%#Eval("I_ID") %>' Visible='<%#Eval("I_ZHUANGTAI").ToString()=="1" %>'  Text="恢复" Width="50px"  OnClientClick="return confirm('确定恢复')" />
                                                           
                                                           
                                                           
                                                        </DataItemTemplate>
                                                        <HeaderStyle HorizontalAlign="Center" />
                                                    </dx:GridViewDataTextColumn>

                                                    <dx:GridViewDataTextColumn Caption="编码" FieldName="I_ID" ShowInCustomizationForm="True" VisibleIndex="21" Visible="False">
                                                    </dx:GridViewDataTextColumn>

                                                </Columns>
                                                <SettingsPager PageSize="50"></SettingsPager>
                                                <ClientSideEvents BeginCallback="function(s,e){HiddenListValue.Set('RowsCount',gvtab7.GetVisibleRowsOnPage());}" Init="function(s,e){AdjustSize(365,gvtab7);}" FocusedRowChanged="function(s,e){gvtab7SelectChange();}"   />
                                                <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                            </dx:ASPxGridView>
                                         
                                        </div>
                                        <div style="border: 1px solid #d0e4fe">
                                            <table style="width: 100%; text-align: right; height: 180px;">
                                                <tr>
                                                    <td><span style="font-size: 12px;">用户号：</span></td>
                                                    <td>
                                                        <dx:ASPxTextBox runat="server" ClientInstanceName="GUAHAO_YHH" ID="txtYongHuHtab7" Width="80%" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                    <td><span style="font-size: 12px;">用户名：</span></td>
                                                    <td colspan="5">
                                                        <dx:ASPxTextBox runat="server" ID="txtYongHuMtab7" ClientInstanceName="GUAHAO_YHM" Width="100%" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td><span style="font-size: 12px;">联系人：</span></td>
                                                    <td>
                                                        <dx:ASPxTextBox runat="server" ID="txtLianXiRtab7" ClientInstanceName="GUAHAO_LXR" Width="80%" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                    <td><span style="font-size: 12px;">联系电话：</span></td>
                                                    <td>
                                                        <dx:ASPxTextBox runat="server" ClientInstanceName="GUAHAO_LXDH" ID="txtLianXiDHtab7" Width="100%" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                    <td><span style="font-size: 12px;">联系部门：</span></td>
                                                    <td colspan="3">
                                                        <dx:ASPxTextBox runat="server" ClientInstanceName="GUAHAO_LXBM" ID="txtLianXiBMtab7" Width="100%" ReadOnly="true" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td><span style="font-size: 12px;">业务员：</span></td>
                                                    <td>
                                                        <dx:ASPxTextBox runat="server" ID="txtYeWuYtab7" Width="80%" ClientInstanceName="GUAHAO_YWY" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                    <td><span style="font-size: 12px;">收费方式：</span></td>
                                                    <td>
                                                        <dx:ASPxTextBox runat="server" ID="txtShouFeiFStab7" ClientInstanceName="GUAHAO_SFFS" Width="100%" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                    <td><span style="font-size: 12px;">邮编：</span></td>
                                                    <td>
                                                        <dx:ASPxTextBox runat="server" ID="txtYouBiantab7" Width="80%" ClientInstanceName="GUAHAO_YB" ReadOnly="true" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                    </td>
                                                    <td><span style="font-size: 12px;">财务邮编：</span></td>
                                                    <td>
                                                        <dx:ASPxTextBox runat="server" ID="txtCaiWuYBtab7" ClientInstanceName="GUAHAO_CWYB" Width="100%" ReadOnly="true" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td><span style="font-size: 12px;">地址：</span></td>
                                                    <td colspan="3">
                                                        <dx:ASPxTextBox runat="server" ID="txtDiZhitab7" Width="100%" ClientInstanceName="GUAHAO_DZ" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                    <td><span style="font-size: 12px;">财务地址：</span></td>
                                                    <td colspan="3">
                                                        <dx:ASPxTextBox runat="server" ID="txtCaiWuDZtab7" ClientInstanceName="GUAHAO_CWDZ" Width="100%" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td><span style="font-size: 12px;">银行账号：</span></td>
                                                    <td colspan="3">
                                                        <dx:ASPxTextBox runat="server" ID="txtYinHangZHtab7" Width="100%" ClientInstanceName="GUAHAO_YHZH" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                    <td><span style="font-size: 12px;">开户户名：</span></td>
                                                    <td colspan="3">
                                                        <dx:ASPxTextBox runat="server" ID="txtKaiHuHMtab7" Width="100%" ClientInstanceName="GUAHAO_KHHM" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td><span style="font-size: 12px;">开户银行：</span></td>
                                                    <td colspan="7">
                                                        <dx:ASPxTextBox runat="server" ID="txtKaiHuYHtab7" ClientInstanceName="GUAHAO_KHYH" Width="100%" ReadOnly="true"></dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                            </table>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="缴费">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <table>
                                                <tr>
                                                    <td style="width: 8%;">
                                                        <dx:ASPxRadioButton runat="server" ID="rbnJiaoFeiJEtab8" Text="缴费金额" GroupName="tab8" ClientInstanceName="rbnJiaoFeiJEtab8"></dx:ASPxRadioButton>
                                                    </td>
                                                    <td style="width: 7%;">
                                                        <asp:Panel runat="server" ID="Panel15">
                                                            <dx:ASPxComboBox runat="server" ID="cbmJiaoFeiJEtab8" Width="80%">
                                                                <Items>
                                                                    <dx:ListEditItem Text="0" Value="0" />
                                                                        <dx:ListEditItem Text="=" Value="1" />
                                                                        <dx:ListEditItem Text=">" Value="2" />
                                                                        <dx:ListEditItem Text=">=" Value="3" />
                                                                        <dx:ListEditItem Text="<" Value="4" />
                                                                        <dx:ListEditItem Text="<=" Value="5" />
                                                                        <dx:ListEditItem Text="<>" Value="6" />
                                                                </Items>
                                                                <ClientSideEvents GotFocus="function(s,e){rbnJiaoFeiJEtab8.SetChecked(true);LoseFocus1();}" />
                                                            </dx:ASPxComboBox>
                                                        </asp:Panel>
                                                    </td>
                                                    <td style="width: 9%;">
                                                        <dx:ASPxTextBox runat="server" ID="txtJiaoFeiJEtab8" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rbnJiaoFeiJEtab8.SetChecked(true);LoseFocus1();}" />
                                                        </dx:ASPxTextBox>
                                                    </td>
                                                    <td style="width: 8%;">
                                                        <dx:ASPxRadioButton runat="server" ID="rbnJiaoFeiRQtab8" Text="缴费日期" GroupName="tab8" ClientInstanceName="rbnJiaoFeiRQtab8"></dx:ASPxRadioButton>
                                                    </td>
                                                    <td style="width: 9%;">
                                                        <dx:ASPxDateEdit ID="txtJiaoFeiRQtab8" runat="server" Width="80%">
                                                            <CalendarProperties ClearButtonText="清除" TodayButtonText="今天"></CalendarProperties>
                                                            <ClientSideEvents GotFocus="function(s,e){rbnJiaoFeiRQtab8.SetChecked(true);LoseFocus1();}" />
                                                        </dx:ASPxDateEdit>
                                                        <%-- <dx:ASPxTextBox runat="server" ID="txtJiaoFeiRQtab8" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rbnJiaoFeiRQtab8.SetChecked(true);}" />
                                                        </dx:ASPxTextBox>--%>
                                                    </td>
                                                    <td style="width: 8%;">
                                                        <dx:ASPxRadioButton runat="server" ID="rbnJiaoFeiLXtab8" Text="缴费类型" GroupName="tab8" ClientInstanceName="rbnJiaoFeiLXtab8"></dx:ASPxRadioButton>
                                                    </td>
                                                    <td style="width: 9%;">
                                                        <asp:Panel runat="server" ID="Panel18">
                                                            <dx:ASPxComboBox runat="server" ID="cbmJiaoFeiLXtab8" Width="80%">
                                                                <Items>
                                                                </Items>
                                                                <ClientSideEvents GotFocus="function(s,e){rbnJiaoFeiLXtab8.SetChecked(true);LoseFocus1();}" />
                                                            </dx:ASPxComboBox>
                                                        </asp:Panel>
                                                    </td>
                                                    <td style="width: 8%;">
                                                        <dx:ASPxRadioButton runat="server" ID="rbnShouFeiRQtab8" Text="收费日期" GroupName="tab8" ClientInstanceName="rbnShouFeiRQtab8"></dx:ASPxRadioButton>
                                                    </td>
                                                    <td style="width: 9%;">
                                                        <dx:ASPxDateEdit ID="txtShouFeiRQtab8" runat="server" Width="80%">
                                                             <CalendarProperties ClearButtonText="清除" TodayButtonText="今天"></CalendarProperties>
                                                            <ClientSideEvents GotFocus="function(s,e){rbnShouFeiRQtab8.SetChecked(true);LoseFocus1();}" />
                                                        </dx:ASPxDateEdit>
                                                        <%-- <dx:ASPxTextBox runat="server" ID="txtShouFeiRQtab8" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rbnShouFeiRQtab8.SetChecked(true);}" />
                                                        </dx:ASPxTextBox>--%>
                                                    </td>
                                                    <td style="width: 8%;">
                                                        <dx:ASPxCheckBox runat="server" ID="chkWeiDaoZtab8" Text="未到账"></dx:ASPxCheckBox>
                                                    </td>
                                                    <td style="width: 8%;">
                                                        <dx:ASPxLabel runat="server" ID="lbZongBiStab8" Text="共0笔"></dx:ASPxLabel>
                                                    </td>
                                                    <td>
                                                        <dx:ASPxButton runat="server" ID="btnImportDatatab8" Text="导入数据"></dx:ASPxButton>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td colspan="12">
                                                        <div>
                                                            <script type="text/javascript">
                                                                function first8(obj, msg, key) {

                                                                    obj.SetFocusedRowIndex(0);
                                                                    gvtab8ScrollToVisibleIndexOnClient(0);
                                                                }

                                                                function last8(obj, msg, key) {
                                                                    var index = obj.GetFocusedRowIndex() - 1;
                                                                    if (obj.GetFocusedRowIndex() == 0) {
                                                                        alert("当前已是第一条");
                                                                    }
                                                                    else {
                                                                        obj.SetFocusedRowIndex(obj.GetFocusedRowIndex() - 1);

                                                                    }
                                                                    gvtab8ScrollToVisibleIndexOnClient(index);
                                                                }

                                                                function next8(obj, msg, key) {
                                                                    var index = obj.GetFocusedRowIndex() + 1;
                                                                    if (obj.GetFocusedRowIndex() == obj.GetVisibleRowsOnPage() - 1) {
                                                                        alert("当前已是最后一条");
                                                                    }
                                                                    else {

                                                                        obj.SetFocusedRowIndex(obj.GetFocusedRowIndex() + 1);

                                                                    }
                                                                    gvtab8ScrollToVisibleIndexOnClient(index);
                                                                }

                                                                function final8(obj, msg, key) {
                                                                    var index = obj.GetVisibleRowsOnPage() - 1;
                                                                    obj.SetFocusedRowIndex(index);
                                                                    gvtab8ScrollToVisibleIndexOnClient(index);
                                                                }
                                                                function gvtab8ScrollToVisibleIndexOnClient(index) {
                                                                    gvtab8.SetVerticalScrollPosition(index * 25);
                                                                }
                                                            </script>
                                                            <table>
                                                                <tr>
                                                                    <td style="width: 70px; cursor: pointer">
                                                                        <div onclick="first8(gvtab8,'setinfo','ID');">
                                                                            <img src="../../../Images/first.jpg" />
                                                                        </div>
                                                                    </td>
                                                                    <td style="width: 70px; cursor: pointer">
                                                                        <div onclick="last8(gvtab8,'setinfo','ID');">
                                                                            <img src="../../../Images/last.jpg" />
                                                                        </div>
                                                                    </td>
                                                                    <td style="width: 70px; cursor: pointer">
                                                                        <div onclick="next8(gvtab8,'setinfo','ID');">
                                                                            <img src="../../../Images/next.jpg" />
                                                                        </div>
                                                                    </td>
                                                                    <td style="width: 70px; cursor: pointer">
                                                                        <div onclick="final8(gvtab8,'setinfo','ID');">
                                                                            <img src="../../../Images/final.jpg" />
                                                                        </div>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </div>
                                                    </td>
                                                </tr>
                                            </table>
                                        </div>
                                        <dx:ASPxGridView ID="gvJiaoFeitab8" ClientInstanceName="gvtab8" runat="server" AutoGenerateColumns="False" KeyFieldName="ID" Theme="Aqua1" Width="100%">
                                            <Columns>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="8%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="20%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="YM" Caption="水量年月" Width="8%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="I_ZWNY" Caption="开帐年月" Width="8%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="N_YINGSHOUJE" Caption="初开金额" Width="9%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="N_JINE" Caption="缴费金额" Width="9%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="D_SHOUFEIRQ" PropertiesTextEdit-DisplayFormatString="{0:yyyy-MM-dd}" Caption="缴费日期" Width="9%">
                                                    <PropertiesTextEdit DisplayFormatString="{0:yyyy-MM-dd}">
                                                    </PropertiesTextEdit>
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="I_TYPE" Caption="缴费类型" Width="9%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="D_DAOZHANGRQ" PropertiesTextEdit-DisplayFormatString="{0:yyyy-MM-dd}" Caption="到账日期" Width="9%">
                                                    <PropertiesTextEdit DisplayFormatString="{0:yyyy-MM-dd}">
                                                    </PropertiesTextEdit>
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_HAOMA" Caption="发票号码" Width="9%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="I_ZHUANGTAI" Caption="发票状态" Width="9%"></dx:GridViewDataTextColumn>
                                            </Columns>
                                            <ClientSideEvents Init="function(s,e){AdjustSize(205,gvtab8);}" />
                                            <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                            <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                        </dx:ASPxGridView>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                        </TabPages>
                    </dx:ASPxPageControl>
                </div>
            </ContentTemplate>
        </asp:UpdatePanel>
          <div style="display:none;">
            <table>
                <tr>
                    <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server">
                    </dx:ASPxGridViewExporter>
                    <dx:ASPxButton ID="btnExport" runat="server" ClientInstanceName="btnExport" Text="导出EXCEL" OnClick="btnExport_Click" UseSubmitBehavior="false">
                    </dx:ASPxButton>
                     <dx:ASPxButton ID="btnExport2" runat="server" ClientInstanceName="btnExport2" Text="导出EXCEL" OnClick="btnExport2_Click" UseSubmitBehavior="false">
                    </dx:ASPxButton> 
                </tr>
            </table>
        </div> 
    </form>
</body>
</html>
